/*
 Navicat Premium Data Transfer

 Source Server         : sqlserver
 Source Server Type    : SQL Server
 Source Server Version : 16001000
 Source Catalog        : HobbyClass
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001000
 File Encoding         : 65001

 Date: 03/12/2024 09:13:57
*/


-- ----------------------------
-- Table structure for bill
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[bill]') AND type IN ('U'))
	DROP TABLE [dbo].[bill]
GO

CREATE TABLE [dbo].[bill] (
  [billId] int  IDENTITY(1,1) NOT NULL,
  [money] decimal(6,2)  NOT NULL,
  [Details] varchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [billType] varchar(10) COLLATE Chinese_PRC_CI_AS  NOT NULL
)
GO

ALTER TABLE [dbo].[bill] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of bill
-- ----------------------------
SET IDENTITY_INSERT [dbo].[bill] ON
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'1', N'800.00', N'学员 S001 购买基础篮球套餐，现金支付', N'入账')
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'2', N'1200.00', N'学员 S002 购买进阶篮球套餐，微信支付', N'入账')
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'3', N'1800.00', N'学员 S003 购买高级篮球套餐，支付宝支付', N'入账')
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'4', N'750.00', N'学员 S004 购买基础游泳套餐，银行卡支付', N'入账')
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'5', N'1100.00', N'学员 S005 购买进阶游泳套餐，现金支付', N'入账')
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'6', N'1600.00', N'学员 S006 购买高级游泳套餐，微信支付', N'入账')
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'7', N'1500.00', N'学员 S007 购买亲子篮球套餐，支付宝支付', N'入账')
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'8', N'1400.00', N'学员 S008 购买亲子游泳套餐，银行卡支付', N'入账')
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'9', N'1000.00', N'学员 S009 购买暑期篮球集训套餐，现金支付', N'入账')
GO

INSERT INTO [dbo].[bill] ([billId], [money], [Details], [billType]) VALUES (N'10', N'950.00', N'学员 S010 购买暑期游泳集训套餐，微信支付', N'入账')
GO

SET IDENTITY_INSERT [dbo].[bill] OFF
GO


-- ----------------------------
-- Table structure for classAll
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[classAll]') AND type IN ('U'))
	DROP TABLE [dbo].[classAll]
GO

CREATE TABLE [dbo].[classAll] (
  [classId] int  IDENTITY(1,1) NOT NULL,
  [weekOfMonth] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [weekDay] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [time] date  NOT NULL,
  [ClassType] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [firstClass] text COLLATE Chinese_PRC_CI_AS  NULL,
  [secondClass] text COLLATE Chinese_PRC_CI_AS  NULL,
  [thirdClass] text COLLATE Chinese_PRC_CI_AS  NULL,
  [fourthClass] text COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[classAll] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of classAll
-- ----------------------------
SET IDENTITY_INSERT [dbo].[classAll] ON
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'1', N'2024年11月第1周', N'周一', N'2024-11-04', N'篮球', N'{"class":"篮球训练","site":"室外场地","teacher":"龙教练"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}')
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'2', N'2024年11月第1周', N'周二', N'2024-11-05', N'篮球', N'{"class":"足球训练","site":"室外场地","teacher":"龙教练"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}')
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'3', N'2024年11月第1周', N'周三', N'2024-11-06', N'篮球', N'{"class":"羽毛球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"游泳池","teacher":"徐文斌"}')
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'4', N'2024年11月第1周', N'周四', N'2024-11-07', N'篮球', N'{"class":"羽毛球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}')
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'5', N'2024年11月第1周', N'周五', N'2024-11-08', N'篮球', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}', N'{"class":"篮球训练","site":"体育馆","teacher":"徐文斌"}')
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'11', N'2024年11月第2周', N'周一', N'2024-11-09', N'游泳', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}')
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'12', N'2024年11月第2周', N'周二', N'2024-11-10', N'游泳', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}')
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'13', N'2024年11月第2周', N'周三', N'2024-11-11', N'游泳', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}')
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'14', N'2024年11月第2周', N'周四', N'2024-11-12', N'游泳', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}')
GO

INSERT INTO [dbo].[classAll] ([classId], [weekOfMonth], [weekDay], [time], [ClassType], [firstClass], [secondClass], [thirdClass], [fourthClass]) VALUES (N'15', N'2024年11月第2周', N'周五', N'2024-11-13', N'游泳', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}', N'{"class":"游泳训练","site":"游泳池","teacher":"龙华"}')
GO

SET IDENTITY_INSERT [dbo].[classAll] OFF
GO


-- ----------------------------
-- Table structure for ClassType
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[ClassType]') AND type IN ('U'))
	DROP TABLE [dbo].[ClassType]
GO

CREATE TABLE [dbo].[ClassType] (
  [typeId] int  IDENTITY(1,1) NOT NULL,
  [typeName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [typedescription] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[ClassType] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of ClassType
-- ----------------------------
SET IDENTITY_INSERT [dbo].[ClassType] ON
GO

INSERT INTO [dbo].[ClassType] ([typeId], [typeName], [typedescription]) VALUES (N'1', N'篮球', N'以篮球技巧训练为主，涵盖运球、投篮等。提升身体协调性与团队协作力，在激情对抗中感受篮球魅力。')
GO

INSERT INTO [dbo].[ClassType] ([typeId], [typeName], [typedescription]) VALUES (N'2', N'游泳', N'教授蛙泳、自由泳等多种泳姿。从基础呼吸、漂浮学起，锻炼全身肌肉，于水中畅享运动乐趣，释放身心压力。')
GO

INSERT INTO [dbo].[ClassType] ([typeId], [typeName], [typedescription]) VALUES (N'3', N'羽毛球', N'专注羽毛球技艺，如握拍、击球。强化反应与协调，在轻盈挥拍间，领略羽球竞技之美，培养坚韧运动精神。')
GO

INSERT INTO [dbo].[ClassType] ([typeId], [typeName], [typedescription]) VALUES (N'4', N'足球', N'绿茵场上研习足球规则与技巧，包括带球、射门。锻炼体能与团队默契，于激烈角逐里，体会足球带来的热血激情。')
GO

INSERT INTO [dbo].[ClassType] ([typeId], [typeName], [typedescription]) VALUES (N'5', N'排球', N'着重排球基本动作，发球、扣球等教学。培养团队配合意识，在跳跃击球中，提升身体灵活性与协作沟通能力。')
GO

INSERT INTO [dbo].[ClassType] ([typeId], [typeName], [typedescription]) VALUES (N'6', N'乒乓球', N'围绕乒乓球技巧，握拍、正反手击球展开。提高反应速度与精准控球，在快速对攻中，彰显国球独特魅力。')
GO

SET IDENTITY_INSERT [dbo].[ClassType] OFF
GO


-- ----------------------------
-- Table structure for coaches
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[coaches]') AND type IN ('U'))
	DROP TABLE [dbo].[coaches]
GO

CREATE TABLE [dbo].[coaches] (
  [coachesId] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [coachesName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [coachesSex] char(2) COLLATE Chinese_PRC_CI_AS  NULL,
  [coachesAge] int  NULL,
  [phone] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [salary] decimal(6,2)  NULL,
  [qualifications] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [teaching_ex] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [professional_bg] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [Honors] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [type] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [starting_time] date  NULL,
  [separation_time] date  NULL,
  [avatar] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[coaches] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of coaches
-- ----------------------------
INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J001', N'李教练', N'男', N'35', N'13611111111', N'8000.00', N'高级篮球教练证', N'8 年篮球教学经验', N'体育教育专业', N'市级篮球教学优秀奖', N'在职', N'2015-03-01', NULL, N'未知头像')
GO

INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J002', N'王教练', N'女', N'32', N'13622222222', N'7500.00', N'中级游泳教练证', N'6 年游泳教学经验', N'运动训练专业', NULL, N'在职', N'2017-05-15', NULL, N'未知头像')
GO

INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J003', N'张教练', N'男', N'38', N'13633333333', N'9000.00', N'高级足球教练证', N'10 年足球教学经验', N'体育教育专业', N'省级足球教练称号', N'在职', N'2013-09-20', NULL, N'未知头像')
GO

INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J004', N'刘教练', N'女', N'30', N'13644444444', N'7000.00', N'初级羽毛球教练证', N'4 年羽毛球教学经验', N'运动康复专业', NULL, N'在职', N'2019-02-10', NULL, N'未知头像')
GO

INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J005', N'陈教练', N'男', N'40', N'13655555555', N'9500.00', N'特级乒乓球教练证', N'12 年乒乓球教学经验', N'体育管理专业', N'全国乒乓球优秀教练奖', N'在职', N'2010-07-05', NULL, N'未知头像')
GO

INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J006', N'赵教练', N'女', N'33', N'13666666666', N'7800.00', N'中级网球教练证', N'7 年网球教学经验', N'运动训练专业', NULL, N'在职', N'2016-11-08', NULL, N'未知头像')
GO

INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J007', N'孙教练', N'男', N'36', N'13677777777', N'8500.00', N'高级田径教练证', N'9 年田径教学经验', N'体育教育专业', N'市级田径教练优秀奖', N'在职', N'2014-06-18', NULL, N'未知头像')
GO

INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J008', N'周教练', N'女', N'31', N'13688888888', N'7200.00', N'初级瑜伽教练证', N'5 年瑜伽教学经验', N'运动康复专业', NULL, N'在职', N'2018-04-25', NULL, N'未知头像')
GO

INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J009', N'吴教练', N'男', N'39', N'13699999999', N'8800.00', N'高级武术教练证', N'11 年武术教学经验', N'体育教育专业', N'省级武术教练称号', N'在职', N'2012-01-12', NULL, N'未知头像')
GO

INSERT INTO [dbo].[coaches] ([coachesId], [coachesName], [coachesSex], [coachesAge], [phone], [salary], [qualifications], [teaching_ex], [professional_bg], [Honors], [type], [starting_time], [separation_time], [avatar]) VALUES (N'J010', N'郑教练', N'女', N'34', N'13600000000', N'8200.00', N'中级舞蹈教练证', N'8 年舞蹈教学经验', N'运动训练专业', NULL, N'在职', N'2017-08-28', NULL, N'未知头像')
GO


-- ----------------------------
-- Table structure for CourseSchedule
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[CourseSchedule]') AND type IN ('U'))
	DROP TABLE [dbo].[CourseSchedule]
GO

CREATE TABLE [dbo].[CourseSchedule] (
  [csId] int  IDENTITY(1,1) NOT NULL,
  [stuId] varchar(30) COLLATE Chinese_PRC_CI_AS  NULL,
  [classId] int  NOT NULL,
  [firstStatus] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [secondStatus] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [thirdStatus] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [fourthStatus] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[CourseSchedule] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of CourseSchedule
-- ----------------------------
SET IDENTITY_INSERT [dbo].[CourseSchedule] ON
GO

INSERT INTO [dbo].[CourseSchedule] ([csId], [stuId], [classId], [firstStatus], [secondStatus], [thirdStatus], [fourthStatus]) VALUES (N'1', N'S001', N'1', N'未到', N' ', N'迟到', N'正常')
GO

INSERT INTO [dbo].[CourseSchedule] ([csId], [stuId], [classId], [firstStatus], [secondStatus], [thirdStatus], [fourthStatus]) VALUES (N'2', N'S001', N'2', N'正常', N'正常', N'正常', N'正常')
GO

INSERT INTO [dbo].[CourseSchedule] ([csId], [stuId], [classId], [firstStatus], [secondStatus], [thirdStatus], [fourthStatus]) VALUES (N'3', N'S001', N'3', N'正常', N'正常', N'正常', N'正常')
GO

INSERT INTO [dbo].[CourseSchedule] ([csId], [stuId], [classId], [firstStatus], [secondStatus], [thirdStatus], [fourthStatus]) VALUES (N'4', N'S001', N'4', N'正常', N'正常', N'正常', N'正常')
GO

INSERT INTO [dbo].[CourseSchedule] ([csId], [stuId], [classId], [firstStatus], [secondStatus], [thirdStatus], [fourthStatus]) VALUES (N'5', N'S001', N'5', N'正常', N'正常', N'正常', N'正常')
GO

SET IDENTITY_INSERT [dbo].[CourseSchedule] OFF
GO


-- ----------------------------
-- Table structure for guardians
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[guardians]') AND type IN ('U'))
	DROP TABLE [dbo].[guardians]
GO

CREATE TABLE [dbo].[guardians] (
  [guardiansId] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Gindex] int  IDENTITY(1,1) NOT NULL,
  [name] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [sex] char(2) COLLATE Chinese_PRC_CI_AS  NULL,
  [age] char(2) COLLATE Chinese_PRC_CI_AS  NULL,
  [phone] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [avatar] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[guardians] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of guardians
-- ----------------------------
SET IDENTITY_INSERT [dbo].[guardians] ON
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G001', N'1', N'张大山', N'男', N'45', N'13812345678', N'未知头像')
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G002', N'2', N'刘梅', N'女', N'42', N'13623456789', N'未知头像')
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G003', N'3', N'王建国', N'男', N'48', N'13334567890', N'未知头像')
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G004', N'4', N'李丽', N'女', N'40', N'13545678901', N'未知头像')
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G005', N'5', N'陈强', N'男', N'46', N'13756789012', N'未知头像')
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G006', N'6', N'赵红', N'女', N'43', N'13967890123', N'未知头像')
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G007', N'7', N'孙勇', N'男', N'47', N'13178901234', N'未知头像')
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G008', N'8', N'周慧', N'女', N'41', N'13089012345', N'未知头像')
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G009', N'9', N'吴刚', N'男', N'44', N'13290123456', N'未知头像')
GO

INSERT INTO [dbo].[guardians] ([guardiansId], [Gindex], [name], [sex], [age], [phone], [avatar]) VALUES (N'G010', N'10', N'郑芳', N'女', N'49', N'13401234567', N'未知头像')
GO

SET IDENTITY_INSERT [dbo].[guardians] OFF
GO


-- ----------------------------
-- Table structure for menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[menu]') AND type IN ('U'))
	DROP TABLE [dbo].[menu]
GO

CREATE TABLE [dbo].[menu] (
  [menuId] int  IDENTITY(1,1) NOT NULL,
  [menuName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [menu_descriptive] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [class_descriptive] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [menu_money] decimal(6,2)  NOT NULL,
  [menu_startTime] date  NOT NULL,
  [menu_stopTime] date  NOT NULL,
  [salesVolume] int  NOT NULL,
  [photo] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[menu] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of menu
-- ----------------------------
SET IDENTITY_INSERT [dbo].[menu] ON
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'1', N'基础篮球套餐', N'适合篮球初学者，掌握基本篮球技能', N'篮球基础运球课程 8 节、篮球传球技巧课程 6 节、篮球投篮入门课程 6 节', N'800.00', N'2024-01-01', N'2024-12-31', N'20', N'未知照片')
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'2', N'进阶篮球套餐', N'针对有一定篮球基础学员，提升实战能力', N'篮球个人进攻技巧课程 10 节、篮球防守策略课程 8 节、篮球团队配合课程 8 节', N'1200.00', N'2024-01-01', N'2024-12-31', N'15', N'未知照片')
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'3', N'高级篮球套餐', N'为高级篮球学员定制，强化专业技能与比赛能力', N'篮球高级运球技巧课程 12 节、篮球战术分析课程 10 节、篮球专项体能训练课程 10 节', N'1800.00', N'2024-01-01', N'2024-12-31', N'10', N'未知照片')
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'4', N'基础游泳套餐', N'适合游泳零基础学员，学习基本游泳技能', N'游泳基础呼吸课程 6 节、游泳漂浮技巧课程 8 节、蛙泳入门课程 8 节', N'750.00', N'2024-01-01', N'2024-12-31', N'25', N'未知照片')
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'5', N'进阶游泳套餐', N'针对会基础游泳学员，提升多种泳姿技能', N'自由泳技巧提升课程 10 节、仰泳入门课程 8 节、蝶泳基础课程 6 节', N'1100.00', N'2024-01-01', N'2024-12-31', N'18', N'未知照片')
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'6', N'高级游泳套餐', N'为高级游泳学员打造，优化泳姿与竞技能力', N'自由泳竞赛训练课程 12 节、仰泳专项训练课程 10 节、蝶泳高级技巧课程 10 节', N'1600.00', N'2024-01-01', N'2024-12-31', N'12', N'未知照片')
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'7', N'亲子篮球套餐', N'适合家长与孩子共同参与篮球学习，增进亲子互动', N'亲子篮球基础课程 10 节、亲子篮球游戏课程 8 节、亲子篮球比赛课程 6 节', N'1500.00', N'2024-01-01', N'2024-12-31', N'8', N'未知照片')
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'8', N'亲子游泳套餐', N'家长与孩子一起学习游泳，享受亲子时光', N'亲子游泳入门课程 10 节、亲子水中游戏课程 8 节、亲子游泳安全课程 6 节', N'1400.00', N'2024-01-01', N'2024-12-31', N'10', N'未知照片')
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'9', N'暑期篮球集训套餐', N'暑期集中训练，快速提升篮球技能', N'暑期篮球强化训练课程 15 节、篮球对抗赛课程 10 节、篮球体能特训课程 10 节', N'1000.00', N'2024-07-01', N'2024-08-31', N'30', N'未知照片')
GO

INSERT INTO [dbo].[menu] ([menuId], [menuName], [menu_descriptive], [class_descriptive], [menu_money], [menu_startTime], [menu_stopTime], [salesVolume], [photo]) VALUES (N'10', N'暑期游泳集训套餐', N'暑期专项游泳集训，突破游泳水平', N'暑期游泳技巧提升课程 15 节、长距离游泳训练课程 10 节、游泳自救课程 8 节', N'950.00', N'2024-07-01', N'2024-08-31', N'28', N'未知照片')
GO

SET IDENTITY_INSERT [dbo].[menu] OFF
GO


-- ----------------------------
-- Table structure for menuAndStu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[menuAndStu]') AND type IN ('U'))
	DROP TABLE [dbo].[menuAndStu]
GO

CREATE TABLE [dbo].[menuAndStu] (
  [maId] int  IDENTITY(1,1) NOT NULL,
  [stuId] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [menuId] int  NOT NULL,
  [surpluClass_count] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [useStart] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[menuAndStu] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of menuAndStu
-- ----------------------------
SET IDENTITY_INSERT [dbo].[menuAndStu] ON
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'1', N'S001', N'1', N'10', N'使用中')
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'2', N'S002', N'2', N'15', N'使用中')
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'3', N'S003', N'3', N'8', N'使用中')
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'4', N'S004', N'4', N'12', N'使用中')
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'5', N'S005', N'5', N'10', N'使用中')
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'6', N'S006', N'6', N'8', N'使用中')
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'7', N'S007', N'7', N'18', N'使用中')
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'8', N'S008', N'8', N'10', N'使用中')
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'9', N'S009', N'9', N'12', N'使用中')
GO

INSERT INTO [dbo].[menuAndStu] ([maId], [stuId], [menuId], [surpluClass_count], [useStart]) VALUES (N'10', N'S010', N'10', N'5', N'使用中')
GO

SET IDENTITY_INSERT [dbo].[menuAndStu] OFF
GO


-- ----------------------------
-- Table structure for sale
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[sale]') AND type IN ('U'))
	DROP TABLE [dbo].[sale]
GO

CREATE TABLE [dbo].[sale] (
  [saler] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [guardiansId] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [menuId] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [dealings_time] date  NOT NULL,
  [dealings_style] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [dealings_count] int  NOT NULL
)
GO

ALTER TABLE [dbo].[sale] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of sale
-- ----------------------------
INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J001', N'G001', N'1', N'2024-03-01', N'现金', N'1')
GO

INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J002', N'G002', N'2', N'2024-04-05', N'微信支付', N'1')
GO

INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J003', N'G003', N'3', N'2024-05-10', N'支付宝', N'1')
GO

INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J004', N'G004', N'4', N'2024-06-15', N'银行卡', N'1')
GO

INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J005', N'G005', N'5', N'2024-07-20', N'现金', N'1')
GO

INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J006', N'G006', N'6', N'2024-08-25', N'微信支付', N'1')
GO

INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J007', N'G007', N'7', N'2024-09-01', N'支付宝', N'1')
GO

INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J008', N'G008', N'8', N'2024-10-05', N'银行卡', N'1')
GO

INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J009', N'G009', N'9', N'2024-11-10', N'现金', N'1')
GO

INSERT INTO [dbo].[sale] ([saler], [guardiansId], [menuId], [dealings_time], [dealings_style], [dealings_count]) VALUES (N'J010', N'G010', N'10', N'2024-12-15', N'微信支付', N'1')
GO


-- ----------------------------
-- Table structure for staff
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[staff]') AND type IN ('U'))
	DROP TABLE [dbo].[staff]
GO

CREATE TABLE [dbo].[staff] (
  [staffId] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [staffName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [staffSex] char(2) COLLATE Chinese_PRC_CI_AS  NULL,
  [staffAge] int  NULL,
  [phone] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [salary] decimal(6,2)  NULL,
  [type] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [starting_time] date  NULL,
  [separation_time] date  NULL,
  [avatar] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[staff] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of staff
-- ----------------------------
INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z001', N'小李', N'男', N'25', N'13311111111', N'4000.00', N'在职', N'2020-05-01', NULL, N'未知头像')
GO

INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z002', N'小王', N'女', N'23', N'13322222222', N'3800.00', N'在职', N'2021-07-10', NULL, N'未知头像')
GO

INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z003', N'小张', N'男', N'26', N'13333333333', N'4200.00', N'在职', N'2019-09-15', NULL, N'未知头像')
GO

INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z004', N'小刘', N'女', N'24', N'13344444444', N'3900.00', N'在职', N'2022-03-20', NULL, N'未知头像')
GO

INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z005', N'小陈', N'男', N'27', N'13355555555', N'4300.00', N'在职', N'2018-11-25', NULL, N'未知头像')
GO

INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z006', N'小赵', N'女', N'22', N'13366666666', N'3700.00', N'在职', N'2023-01-05', NULL, N'未知头像')
GO

INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z007', N'小孙', N'男', N'28', N'13377777777', N'4500.00', N'在职', N'2017-06-30', NULL, N'未知头像')
GO

INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z008', N'小周', N'女', N'23', N'13388888888', N'3800.00', N'在职', N'2022-09-08', NULL, N'未知头像')
GO

INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z009', N'小吴', N'男', N'26', N'13399999999', N'4200.00', N'在职', N'2019-12-12', NULL, N'未知头像')
GO

INSERT INTO [dbo].[staff] ([staffId], [staffName], [staffSex], [staffAge], [phone], [salary], [type], [starting_time], [separation_time], [avatar]) VALUES (N'Z010', N'小郑', N'女', N'25', N'13300000000', N'4000.00', N'在职', N'2021-04-18', NULL, N'未知头像')
GO


-- ----------------------------
-- Table structure for student
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[student]') AND type IN ('U'))
	DROP TABLE [dbo].[student]
GO

CREATE TABLE [dbo].[student] (
  [stuId] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [stuIndex] int  IDENTITY(1,1) NOT NULL,
  [stuName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [sex] char(2) COLLATE Chinese_PRC_CI_AS  NULL,
  [age] int  NULL,
  [guardiansId] varchar(30) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[student] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of student
-- ----------------------------
SET IDENTITY_INSERT [dbo].[student] ON
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S001', N'1', N'小明', N'男', N'10', N'G001')
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S002', N'2', N'小花', N'女', N'11', N'G002')
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S003', N'3', N'小刚', N'男', N'9', N'G003')
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S004', N'4', N'小美', N'女', N'12', N'G004')
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S005', N'5', N'小强', N'男', N'10', N'G005')
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S006', N'6', N'小丽', N'女', N'11', N'G006')
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S007', N'7', N'小辉', N'男', N'9', N'G007')
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S008', N'8', N'小敏', N'女', N'12', N'G008')
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S009', N'9', N'小宇', N'男', N'10', N'G009')
GO

INSERT INTO [dbo].[student] ([stuId], [stuIndex], [stuName], [sex], [age], [guardiansId]) VALUES (N'S010', N'10', N'小萱', N'女', N'11', N'G010')
GO

SET IDENTITY_INSERT [dbo].[student] OFF
GO


-- ----------------------------
-- Table structure for users
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[users]') AND type IN ('U'))
	DROP TABLE [dbo].[users]
GO

CREATE TABLE [dbo].[users] (
  [userId] varchar(30) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [userName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [passWord] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [roll] int DEFAULT 1 NULL
)
GO

ALTER TABLE [dbo].[users] SET (LOCK_ESCALATION = TABLE)
GO


-- ----------------------------
-- Records of users
-- ----------------------------
INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'A001', N'超级管理员', N'admin123', N'5')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G001', N'张大山', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G002', N'刘梅', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G003', N'王建国', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G004', N'李丽', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G005', N'陈强', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G006', N'赵红', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G007', N'孙勇', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G008', N'周慧', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G009', N'吴刚', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'G010', N'郑芳', N'123456', N'2')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J001', N'李教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J002', N'王教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J003', N'张教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J004', N'刘教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J005', N'陈教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J006', N'赵教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J007', N'孙教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J008', N'周教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J009', N'吴教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'J010', N'郑教练', N'coach123', N'3')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z001', N'小李', N'staff123', N'4')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z002', N'小王', N'staff123', N'4')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z003', N'小张', N'staff123', N'4')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z004', N'小刘', N'staff123', N'4')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z005', N'小陈', N'staff123', N'4')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z006', N'小赵', N'staff123', N'4')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z007', N'小孙', N'staff123', N'4')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z008', N'小周', N'staff123', N'4')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z009', N'小吴', N'staff123', N'4')
GO

INSERT INTO [dbo].[users] ([userId], [userName], [passWord], [roll]) VALUES (N'Z010', N'小郑', N'staff123', N'4')
GO


-- ----------------------------
-- Auto increment value for bill
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[bill]', RESEED, 10)
GO


-- ----------------------------
-- Primary Key structure for table bill
-- ----------------------------
ALTER TABLE [dbo].[bill] ADD CONSTRAINT [PK__bill__6D903F0385258798] PRIMARY KEY CLUSTERED ([billId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for classAll
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[classAll]', RESEED, 1001)
GO


-- ----------------------------
-- Primary Key structure for table classAll
-- ----------------------------
ALTER TABLE [dbo].[classAll] ADD CONSTRAINT [PK__classAll__7577347E36D57053] PRIMARY KEY CLUSTERED ([classId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for ClassType
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[ClassType]', RESEED, 11)
GO


-- ----------------------------
-- Primary Key structure for table ClassType
-- ----------------------------
ALTER TABLE [dbo].[ClassType] ADD CONSTRAINT [PK__ClassTyp__F04DF13A9720758E] PRIMARY KEY CLUSTERED ([typeId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table coaches
-- ----------------------------
ALTER TABLE [dbo].[coaches] ADD CONSTRAINT [PK__coaches__04D2D46512DCC3B4] PRIMARY KEY CLUSTERED ([coachesId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for CourseSchedule
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[CourseSchedule]', RESEED, 1001)
GO


-- ----------------------------
-- Primary Key structure for table CourseSchedule
-- ----------------------------
ALTER TABLE [dbo].[CourseSchedule] ADD CONSTRAINT [PK__CourseSc__2C52D1BCF84B7D6F] PRIMARY KEY CLUSTERED ([csId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for guardians
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[guardians]', RESEED, 10)
GO


-- ----------------------------
-- Primary Key structure for table guardians
-- ----------------------------
ALTER TABLE [dbo].[guardians] ADD CONSTRAINT [PK__guardian__ADD27857CAD315BC] PRIMARY KEY CLUSTERED ([guardiansId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for menu
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[menu]', RESEED, 10)
GO


-- ----------------------------
-- Primary Key structure for table menu
-- ----------------------------
ALTER TABLE [dbo].[menu] ADD CONSTRAINT [PK__menu__3B407174E07BBDB0] PRIMARY KEY CLUSTERED ([menuId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for menuAndStu
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[menuAndStu]', RESEED, 10)
GO


-- ----------------------------
-- Primary Key structure for table menuAndStu
-- ----------------------------
ALTER TABLE [dbo].[menuAndStu] ADD CONSTRAINT [PK__menuAndS__7A3E3D4591638887] PRIMARY KEY CLUSTERED ([maId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Primary Key structure for table staff
-- ----------------------------
ALTER TABLE [dbo].[staff] ADD CONSTRAINT [PK__staff__6465E07ECD7F8339] PRIMARY KEY CLUSTERED ([staffId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for student
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[student]', RESEED, 10)
GO


-- ----------------------------
-- Primary Key structure for table student
-- ----------------------------
ALTER TABLE [dbo].[student] ADD CONSTRAINT [PK__student__AEC9BF8F673A1528] PRIMARY KEY CLUSTERED ([stuId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Checks structure for table users
-- ----------------------------
ALTER TABLE [dbo].[users] ADD CONSTRAINT [CK__users__roll__37A5467C] CHECK ([roll]=(5) OR [roll]=(4) OR [roll]=(3) OR [roll]=(2) OR [roll]=(1))
GO


-- ----------------------------
-- Primary Key structure for table users
-- ----------------------------
ALTER TABLE [dbo].[users] ADD CONSTRAINT [PK__users__CB9A1CFF5ED9F1FC] PRIMARY KEY CLUSTERED ([userId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO

